class CreateUsers < ActiveRecord::Migration
  def change
    create_table :users do |t|
      t.string :username
      t.string :password
      t.string :email
      #t.string :firstname
      #t.string :lastname
      #t.string :nationality
      #t.string :id_num
      #t.string :grantdept
      #t.string :department
      #t.string :company
      #t.string :workphone
      #t.string :homephone
      #t.string :mobilephone
      #t.string :address
      #t.string :city
      #t.string :state
      #t.string :country
      #t.string :zip
      #t.string :notes
      #t.string :changeuserinfo
      #t.integer :enableportallogin
      #t.datetime :creationdate
      #t.string :creationby
      #t.datetime :updatedate
      #t.string :updateby
      #t.date :id_startdate
      #t.date :id_expiredate

      t.timestamps
    end
  end
end
